﻿using System;
using System.Linq;
using System.Text;
using SqlSugar;

namespace Models
{
    ///<summary>
    ///工单管理实体表
    ///</summary>
    [SugarTable("WORKORDERMODEL")]
    public partial class WORKORDERMODEL
    {
           public WORKORDERMODEL(){


           }
           /// <summary>
           /// Desc:工单主键
           /// Default:
           /// Nullable:False
           /// </summary>           
           [SugarColumn(IsPrimaryKey=true)]
           public long WORKORDERID {get;set;}

           /// <summary>
           /// Desc:工单编码
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string WORKORDERCODE {get;set;}

           /// <summary>
           /// Desc:工单类型(数据字典)
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string WORKORDERTYPEID {get;set;}

           /// <summary>
           /// Desc:产品主数据(产品物料实体表)
           /// Default:
           /// Nullable:True
           /// </summary>           
           public long? PRODUCTMASTERDATAID {get;set;}

           /// <summary>
           /// Desc:工艺路线(工艺路线实体表)
           /// Default:
           /// Nullable:True
           /// </summary>           
           public long? ROUTINGID {get;set;}

           /// <summary>
           /// Desc:产线(产线管理实体表)
           /// Default:
           /// Nullable:True
           /// </summary>           
           public long? PRODUCTIONLINEID {get;set;}

           /// <summary>
           /// Desc:计划结束时间
           /// Default:
           /// Nullable:True
           /// </summary>           
           public DateTime? WORKORDERTIME {get;set;}

           /// <summary>
           /// Desc:状态
           /// Default:
           /// Nullable:True
           /// </summary>           
           public bool WORKORDERSTATUS {get;set;}

           /// <summary>
           /// Desc:工序进度
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string PROCESSPROGRESS {get;set;}

           /// <summary>
           /// Desc:数量
           /// Default:
           /// Nullable:True
           /// </summary>           
           public long? WORKORDERNUM {get;set;}

           /// <summary>
           /// Desc:是否允许跳工序
           /// Default:
           /// Nullable:True
           /// </summary>           
           public bool WORKORDERISNO {get;set;}

           /// <summary>
           /// Desc:附件
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string WORKORDERANNEX {get;set;}

           /// <summary>
           /// Desc:备注
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string WORKORDERREMARK {get;set;}

           /// <summary>
           /// Desc:创建人
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string CREATEBY {get;set;}

           /// <summary>
           /// Desc:修改人
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string UPDATEBY {get;set;}

           /// <summary>
           /// Desc:创建时间
           /// Default:
           /// Nullable:True
           /// </summary>           
           public DateTime? CREATETIME {get;set;}

           /// <summary>
           /// Desc:修改时间
           /// Default:
           /// Nullable:True
           /// </summary>           
           public DateTime? UPDATETIME {get;set;}

           /// <summary>
           /// Desc:逻辑删除
           /// Default:
           /// Nullable:True
           /// </summary>           
           public bool ISDELETED {get;set;}

           /// <summary>
           /// Desc:已完成数量
           /// Default:
           /// Nullable:True
           /// </summary>           
           public long? COMPLETEDNUM {get;set;}

           /// <summary>
           /// Desc:进度
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string PROGRESS {get;set;}

           /// <summary>
           /// Desc:实际开始时间
           /// Default:
           /// Nullable:True
           /// </summary>           
           public DateTime? ACTUALSTARTTIME {get;set;}

           /// <summary>
           /// Desc:实际结束时间
           /// Default:
           /// Nullable:True
           /// </summary>           
           public DateTime? ACTUALENDTIME {get;set;}

           /// <summary>
           /// Desc:投入数量
           /// Default:
           /// Nullable:True
           /// </summary>           
           public long? QUANTITYNUM {get;set;}

           /// <summary>
           /// Desc:良品数量
           /// Default:
           /// Nullable:True
           /// </summary>           
           public long? GOODNUM {get;set;}

           /// <summary>
           /// Desc:报废数量
           /// Default:
           /// Nullable:True
           /// </summary>           
           public long? FAILNUM {get;set;}

           /// <summary>
           /// Desc:来源
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string SOURCE {get;set;}

           /// <summary>
           /// Desc:源工单号
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string TICKETNUMBER {get;set;}

           /// <summary>
           /// Desc:客户
           /// Default:
           /// Nullable:True
           /// </summary>           
           public string WORKCUSTOMER {get;set;}

           /// <summary>
           /// Desc:计划开始时间
           /// Default:NULL
           /// Nullable:True
           /// </summary>           
           public DateTime? WORKSTARTTIME {get;set;}

    }
}
